UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bho4dwTCDdgY34/yRS9MQy7HADxvo2cZRPkWG0KR9dw='
WHERE
key_id = '331ca05b53f1ebdd5b256e914e1cfc777ca915219d9f1154ff96528ac6bd239e'
AND (
token = 'bho4dwTCDdgY34/yRS9MQy7HADxvo2cZRPkWG0KR9dw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)