UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uAIyUZ505CKzi1a/NbCLG9XaNR5gbtnep4FOkD1fX2M='
WHERE
key_id = '27d29da70f47627d8dcfb1c1ddaf64cf781e142d39ccfab3088503630f1999ef'
AND (
token = 'uAIyUZ505CKzi1a/NbCLG9XaNR5gbtnep4FOkD1fX2M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)