UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G8E0Nsg87tqaK7GY7USeVuhcmE6+QtMISKt3d/boSQI='
WHERE
key_id = 'a729c7341763c2dc39e43e7def52edeb0a2ca90b4be7998b6bf980d87710585a'
AND (
token = 'G8E0Nsg87tqaK7GY7USeVuhcmE6+QtMISKt3d/boSQI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)