UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZBNJJFVQWtAurWhKIwTcVyPaO3FlXlV9wQ6yLP1buL4='
WHERE
key_id = '208d891a2e3e6f63faa502d357cc3daf7368b9ff2490b33dc7fd5fd83dfc5d1b'
AND (
token = 'ZBNJJFVQWtAurWhKIwTcVyPaO3FlXlV9wQ6yLP1buL4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)