UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eZjkkevm9EfctxWXt6TLVnEEkfPdM3AtjfLP2mCVAgU='
WHERE
key_id = '3dcafb40b65cf2bc509e9a8e338dd555ba1f3f93c7ebc1282233dd42b65da17e'
AND (
token = 'eZjkkevm9EfctxWXt6TLVnEEkfPdM3AtjfLP2mCVAgU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)