UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sYcWDEJULw9XGOqeUUpWGWS0lW1lZDgc//yw7sROp9I='
WHERE
key_id = 'c0ea2971e3f0aaed36ff5b7c147a9d33b1f5aab62060a051b80e07c8c2baae2e'
AND (
token = 'sYcWDEJULw9XGOqeUUpWGWS0lW1lZDgc//yw7sROp9I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)