UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hZb3jEqRKujE4NU1Mt/v64RZMQ5XvfM3JPcgLoSnQlw='
WHERE
key_id = '024f7f4fcc8b1412fb3f77b55066f6726fb8fb40bac0e8b5e0d36e0f9f678d69'
AND (
token = 'hZb3jEqRKujE4NU1Mt/v64RZMQ5XvfM3JPcgLoSnQlw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)