UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0U06peIjCHZssSzDgOwe9eVgjCY4SyG2JPWudf7tWRU='
WHERE
key_id = 'f88d55eac701192cae41996b0b7b935efe1be960b79059d64ebdfc7fd267ce75'
AND (
token = '0U06peIjCHZssSzDgOwe9eVgjCY4SyG2JPWudf7tWRU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)