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