UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zPfgegcv9tSn9OVM3Zvkk9ERNa0u/d5Iw3eoM5IYvu0='
WHERE
key_id = '4a1e5ce0145808284ca79fa99ac624e75e39b27dd76f88773c3ed8a2358190e7'
AND (
token = 'zPfgegcv9tSn9OVM3Zvkk9ERNa0u/d5Iw3eoM5IYvu0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)