UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WMcaFfEBM+AkDf8Tjv8Ulc+Vaywv1H0PjXsHRmNh/8Y='
WHERE
key_id = 'de6c582fc9f1ad86c750d6cac622725c2f00dea212c113b047dcfb7ff4454966'
AND (
token = 'WMcaFfEBM+AkDf8Tjv8Ulc+Vaywv1H0PjXsHRmNh/8Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)