UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SiE6EXMT10wmL+jtv731KokxSvzY6mD+L/fOwuv6vMQ='
WHERE
key_id = '9970600972c5191e97c14757f0dee09126798823fb24cb512c5cbd8de1aa5fc4'
AND (
token = 'SiE6EXMT10wmL+jtv731KokxSvzY6mD+L/fOwuv6vMQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)