UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6EMeMURkKcphCuTJb4AisAjb6gXPSpF/yn6xJrXYdJU='
WHERE
key_id = '92c39e8dd6afa6f55438158380d907b25bf88552a993fb955334c3dab6f05314'
AND (
token = '6EMeMURkKcphCuTJb4AisAjb6gXPSpF/yn6xJrXYdJU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)