UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vcff5SyO6yS5xDgHlbk1oEAciMdhPMR3d5x2NaFOVhA='
WHERE
key_id = 'a88fc6934490ec20dafdb1b1b4e62488b4026186e4519377e3fedaabcb839c68'
AND (
token = 'vcff5SyO6yS5xDgHlbk1oEAciMdhPMR3d5x2NaFOVhA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)