UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CS3i7W5DjLrq9Z3fpVEPWFeQd6dnUCEn/gPINYci7RY='
WHERE
key_id = '29ae366305005fcd7fecb1970424a9e01983455f4f6f066d87f705ff42413faf'
AND (
token = 'CS3i7W5DjLrq9Z3fpVEPWFeQd6dnUCEn/gPINYci7RY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)