UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D701gbeVNvd21gD0b8L10SACKwo+o9XnuPKLECUZygE='
WHERE
key_id = 'b08f4dd6bcc915f5b5fa2d4f47bf344697ef24e0c5030623863b2612720ee7a7'
AND (
token = 'D701gbeVNvd21gD0b8L10SACKwo+o9XnuPKLECUZygE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)