UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hA1xmaFuZshBSScWxwtP4cwG02qb2JIq09YaGc5jbUA='
WHERE
key_id = '1985f6bf8a4c7e1e1c6dd1ad4028670b5ba8c74a7fec9c19b72515686451f363'
AND (
token = 'hA1xmaFuZshBSScWxwtP4cwG02qb2JIq09YaGc5jbUA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)