UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hk8smPrGFCpeXL0jEhC9Yw0Hhm7MFS5x0vDL2N6MafI='
WHERE
key_id = '7b97569c88d9b67610518983356b26e030a843a6de29f333097522be52c8585e'
AND (
token = 'hk8smPrGFCpeXL0jEhC9Yw0Hhm7MFS5x0vDL2N6MafI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)