UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vNxUY+YEhvotmIZKPNAkNkAuwz9/LoecYOeeBqj8UXg='
WHERE
key_id = '889c22e3bae504d91921bc96c6fc440397f56c766f880485c231e6dd2719697a'
AND (
token = 'vNxUY+YEhvotmIZKPNAkNkAuwz9/LoecYOeeBqj8UXg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)