UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hn8OOlpEkqqXsa42rkMnFp+RF9vG8Z/XWpafr43lez4='
WHERE
key_id = 'c812b366bc65640c02011e8f214e577b9759fca8705fa2b8f3c231383a4991ce'
AND (
token = 'hn8OOlpEkqqXsa42rkMnFp+RF9vG8Z/XWpafr43lez4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)