UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zZKgmxq7IiqrJnRziD5G0LS2jCoDI53XTbiHD6hG4L8='
WHERE
key_id = '0090ef8840f026fe6178712914965a0788e441e2e7a71306abfc8d20fcba6c9b'
AND (
token = 'zZKgmxq7IiqrJnRziD5G0LS2jCoDI53XTbiHD6hG4L8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)