UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CqEzghiOBQ+1lkJZNhc/FW6IhXIS/gNz++vihyudJrs='
WHERE
key_id = 'f07cb5adeecf7d64a1c87180bfecdf2c090e478c95d165cc1c821a44d87d33aa'
AND (
token = 'CqEzghiOBQ+1lkJZNhc/FW6IhXIS/gNz++vihyudJrs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)