UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JVzb6111cwgO+2z1ugTvtekONbsxyE1PILbMThq4g3A='
WHERE
key_id = 'ba6c1f5801bd8c15b7454ff731470cf2c56448f8c469aaef09f2f265791e7b85'
AND (
token = 'JVzb6111cwgO+2z1ugTvtekONbsxyE1PILbMThq4g3A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)