UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V1bdTtDxUT2p3RPWA+Nm6NuwBmGyRkylOwnBJ2Xumcg='
WHERE
key_id = 'ae3e9e56d05be0522e62ffbc6267c74fa58e6e358e27b5dfda18d534535ee6b8'
AND (
token = 'V1bdTtDxUT2p3RPWA+Nm6NuwBmGyRkylOwnBJ2Xumcg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)