UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tXzenI/Ak0bt5d1IiKZzrMR0BhGNoJAJBuNsYLa8xo4='
WHERE
key_id = 'd2e239f55f252de10b198a23f2b97acc075fd24cf9c58e1d1916d37c122052cd'
AND (
token = 'tXzenI/Ak0bt5d1IiKZzrMR0BhGNoJAJBuNsYLa8xo4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)