UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8BqrKHCUkMQB4yUT5yOtowPtcmBMlDzVkNGWU16HcSI='
WHERE
key_id = '779228e88448fae74ec6b5aa0131da4c4f118d7ea968b6b114febf81f4ec75db'
AND (
token = '8BqrKHCUkMQB4yUT5yOtowPtcmBMlDzVkNGWU16HcSI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)