UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R30itFqaMlOzamb7T7x1NwS5eDPMRFeBq2MSejfKzY4='
WHERE
key_id = '6aaa02ea004e1200840b5975eef34e31037c24b94caf92ad8627e6a41f358199'
AND (
token = 'R30itFqaMlOzamb7T7x1NwS5eDPMRFeBq2MSejfKzY4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)