UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C/CEFszKjqol2CM4h4u5IM6zPbFe1g/b0BaIk+6C7gA='
WHERE
key_id = '674e295f2b98fdd4110983bcf1fd0f39bc62955f1f5e906af848097e257b050f'
AND (
token = 'C/CEFszKjqol2CM4h4u5IM6zPbFe1g/b0BaIk+6C7gA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)