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