UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pGyVXkpuCD0AdttNaqsUWht9AVs2Bz5grOX6ulmZQu4='
WHERE
key_id = 'dabc6af61239af65e5e10359464053d253c814f6c77052d49ca589a21ce88d63'
AND (
token = 'pGyVXkpuCD0AdttNaqsUWht9AVs2Bz5grOX6ulmZQu4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)