UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pP0huJ+ZbEmy2mjxmEG57gWzeL8PNwRsnpDdyRSYGs8='
WHERE
key_id = '29d836e16a51c5846b5621a35aed100c2f8d9204fa7366add3ba68218888bd8d'
AND (
token = 'pP0huJ+ZbEmy2mjxmEG57gWzeL8PNwRsnpDdyRSYGs8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)