UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y39W92zWUsaPz+RaEnvWHvgNy77cilA5jqH3GpoFjKM='
WHERE
key_id = 'acccabe72a0671cbc50ee973a21e724882cae6101f363e132756af8dc64a8ea2'
AND (
token = 'y39W92zWUsaPz+RaEnvWHvgNy77cilA5jqH3GpoFjKM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)