UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9qZMwa8ChPevbOYhcYwV+k8CsvtFQzViF0O7jFVsEuw='
WHERE
key_id = 'ebc7dae0e45097a850d504f7087444950f3700ed3a9eddb38ad60021c0d7a67e'
AND (
token = '9qZMwa8ChPevbOYhcYwV+k8CsvtFQzViF0O7jFVsEuw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)