UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I8AwkPmycVdvXz+bYXr0x1DV92osbjOk/tXGoi0DjCU='
WHERE
key_id = '9bb4d51792fee0ad4ba28c2c8f04b6391f249b3d2cd677f62e3b09789679de99'
AND (
token = 'I8AwkPmycVdvXz+bYXr0x1DV92osbjOk/tXGoi0DjCU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)