UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X4UonMeHaQ8osMJG283A+JfF61jsUGuR8RSDNO16nAw='
WHERE
key_id = 'aa64fcc26ae417ecc81b9b63eafba83bfb46611f59350eef7f62b25a841ea975'
AND (
token = 'X4UonMeHaQ8osMJG283A+JfF61jsUGuR8RSDNO16nAw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)