UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vNTm2Q4EBkqVMP/fqydgJVPoGrYcrHDjbxLjLt3zWco='
WHERE
key_id = '3417d98156390ac2bc50c1b9cdede79fc99715ff5a00eb456a5651a5b918631f'
AND (
token = 'vNTm2Q4EBkqVMP/fqydgJVPoGrYcrHDjbxLjLt3zWco='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)