UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q0YKQ2JdT8PGGJ0xQw6O4TkULYyJoa6plaa07aD5f6A='
WHERE
key_id = 'c0d8c014a3bef6444327af9b953daa5dfd1465b39e428368862c65be40c5e634'
AND (
token = 'q0YKQ2JdT8PGGJ0xQw6O4TkULYyJoa6plaa07aD5f6A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)