UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+yPr8niIDvPFibWEyyGTk/9FR3DGtzXyltcJ4227tbU='
WHERE
key_id = '8b4881725ea1f5b33c0ed63f04bf9fa9ca715ce7aced1e0f39f143adb5708f0a'
AND (
token = '+yPr8niIDvPFibWEyyGTk/9FR3DGtzXyltcJ4227tbU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)