UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3DTHMzDRuBvIWzFLeuKnl5hrEAiRa82CWcoz95BBdXc='
WHERE
key_id = '8e485bff5769c65640aae5935b9edbe52e9792e6480ff7a22b5af9f81518dfd5'
AND (
token = '3DTHMzDRuBvIWzFLeuKnl5hrEAiRa82CWcoz95BBdXc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)